Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 848411 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 2442 |
| Duplicate rows (%) | 0.3% |
| Total size in memory | 113.3 MiB |
| Average record size in memory | 140.0 B |
Variable types
| DateTime | 1 |
|---|---|
| Numeric | 22 |
| Categorical | 1 |
| Dataset has 2442 (0.3%) duplicate rows | Duplicates |
RoomTemperature is highly correlated with RelativeHumiditySupplyAir and 1 other fields | High correlation |
HeaterPerc is highly correlated with HeatingPower | High correlation |
CoolerPerc is highly correlated with CoolingPower | High correlation |
TempSupplyAir is highly correlated with RelativeHumiditySupplyAir and 1 other fields | High correlation |
RelativeHumiditySupplyAir is highly correlated with RoomTemperature and 3 other fields | High correlation |
HeatingPower is highly correlated with HeaterPerc and 1 other fields | High correlation |
CoolingPower is highly correlated with CoolerPerc | High correlation |
AirTemperature is highly correlated with RoomTemperature and 4 other fields | High correlation |
BrightnessNorth is highly correlated with AirTemperature and 5 other fields | High correlation |
BrightnessEast is highly correlated with BrightnessNorth and 4 other fields | High correlation |
BrightnessSouth is highly correlated with BrightnessNorth and 4 other fields | High correlation |
BrightnessWest is highly correlated with AirTemperature and 5 other fields | High correlation |
dwpt is highly correlated with RelativeHumiditySupplyAir and 1 other fields | High correlation |
rhum is highly correlated with BrightnessNorth and 4 other fields | High correlation |
tsun is highly correlated with BrightnessNorth and 4 other fields | High correlation |
RoomTemperature is highly correlated with RelativeHumiditySupplyAir | High correlation |
HeaterPerc is highly correlated with HeatingPower | High correlation |
TempSupplyAir is highly correlated with RelativeHumiditySupplyAir and 1 other fields | High correlation |
RelativeHumiditySupplyAir is highly correlated with RoomTemperature and 3 other fields | High correlation |
HeatingPower is highly correlated with HeaterPerc and 1 other fields | High correlation |
AirTemperature is highly correlated with RelativeHumiditySupplyAir and 4 other fields | High correlation |
BrightnessNorth is highly correlated with AirTemperature and 5 other fields | High correlation |
BrightnessEast is highly correlated with BrightnessNorth and 3 other fields | High correlation |
BrightnessSouth is highly correlated with BrightnessNorth and 4 other fields | High correlation |
BrightnessWest is highly correlated with AirTemperature and 4 other fields | High correlation |
dwpt is highly correlated with RelativeHumiditySupplyAir and 1 other fields | High correlation |
rhum is highly correlated with AirTemperature and 5 other fields | High correlation |
tsun is highly correlated with BrightnessNorth and 4 other fields | High correlation |
HeaterPerc is highly correlated with HeatingPower | High correlation |
CoolerPerc is highly correlated with CoolingPower | High correlation |
TempSupplyAir is highly correlated with RelativeHumiditySupplyAir | High correlation |
RelativeHumiditySupplyAir is highly correlated with TempSupplyAir | High correlation |
HeatingPower is highly correlated with HeaterPerc | High correlation |
CoolingPower is highly correlated with CoolerPerc | High correlation |
AirTemperature is highly correlated with dwpt | High correlation |
BrightnessNorth is highly correlated with BrightnessEast and 3 other fields | High correlation |
BrightnessEast is highly correlated with BrightnessNorth and 3 other fields | High correlation |
BrightnessSouth is highly correlated with BrightnessNorth and 4 other fields | High correlation |
BrightnessWest is highly correlated with BrightnessNorth and 3 other fields | High correlation |
dwpt is highly correlated with AirTemperature | High correlation |
rhum is highly correlated with BrightnessSouth | High correlation |
tsun is highly correlated with BrightnessNorth and 3 other fields | High correlation |
HeaterPerc is highly correlated with HeatingPower | High correlation |
CoolerPerc is highly correlated with CoolingPower | High correlation |
TempSupplyAir is highly correlated with RelativeHumiditySupplyAir | High correlation |
RelativeHumiditySupplyAir is highly correlated with TempSupplyAir | High correlation |
HeatingPower is highly correlated with HeaterPerc | High correlation |
CoolingPower is highly correlated with CoolerPerc | High correlation |
AirTemperature is highly correlated with BrightnessNorth and 4 other fields | High correlation |
BrightnessNorth is highly correlated with AirTemperature and 5 other fields | High correlation |
BrightnessEast is highly correlated with BrightnessNorth and 4 other fields | High correlation |
BrightnessSouth is highly correlated with AirTemperature and 5 other fields | High correlation |
BrightnessWest is highly correlated with AirTemperature and 5 other fields | High correlation |
dwpt is highly correlated with AirTemperature | High correlation |
rhum is highly correlated with AirTemperature and 5 other fields | High correlation |
tsun is highly correlated with BrightnessNorth and 4 other fields | High correlation |
Room has 142676 (16.8%) zeros | Zeros |
AirqualityPerc has 160732 (18.9%) zeros | Zeros |
HeaterPerc has 497718 (58.7%) zeros | Zeros |
CoolerPerc has 684100 (80.6%) zeros | Zeros |
HeatingPower has 635438 (74.9%) zeros | Zeros |
CoolingPower has 754961 (89.0%) zeros | Zeros |
WindDirection has 304105 (35.8%) zeros | Zeros |
BrightnessNorth has 414876 (48.9%) zeros | Zeros |
BrightnessEast has 414388 (48.8%) zeros | Zeros |
BrightnessSouth has 415732 (49.0%) zeros | Zeros |
BrightnessWest has 413508 (48.7%) zeros | Zeros |
BucketAttendees has 818422 (96.5%) zeros | Zeros |
prcp has 734300 (86.6%) zeros | Zeros |
tsun has 568344 (67.0%) zeros | Zeros |
coco has 15378 (1.8%) zeros | Zeros |
Reproduction
| Analysis started | 2022-05-07 10:29:56.760841 |
|---|---|
| Analysis finished | 2022-05-07 10:35:32.280584 |
| Duration | 5 minutes and 35.52 seconds |
| Software version | pandas-profiling v3.2.0 |
| Download configuration | config.json |
df_index
Date
| Distinct | 140231 |
|---|---|
| Distinct (%) | 16.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.5 MiB |
| Minimum | 2018-01-01 00:00:00 |
|---|---|
| Maximum | 2021-12-31 23:45:00 |
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.496415063 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 142676 |
| Zeros (%) | 16.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.709282362 |
|---|---|
| Coefficient of variation (CV) | 0.6846947798 |
| Kurtosis | -1.269891184 |
| Mean | 2.496415063 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.0007064616374 |
| Sum | 2117986 |
| Variance | 2.921646193 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 142676 | |
| 3 | 141685 | |
| 4 | 141232 | |
| 5 | 141073 | |
| 2 | 140893 | |
| 1 | 140852 |
| Value | Count | Frequency (%) |
| 0 | 142676 | |
| 1 | 140852 | |
| 2 | 140893 | |
| 3 | 141685 | |
| 4 | 141232 | |
| 5 | 141073 |
| Value | Count | Frequency (%) |
| 5 | 141073 | |
| 4 | 141232 | |
| 3 | 141685 | |
| 2 | 140893 | |
| 1 | 140852 | |
| 0 | 142676 |
| Distinct | 140 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.16507624 |
| Minimum | 12 |
|---|---|
| Maximum | 27.60000038 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 12 |
|---|---|
| 5-th percentile | 20.10000038 |
| Q1 | 21.60000038 |
| median | 22.29999924 |
| Q3 | 22.89999962 |
| 95-th percentile | 23.70000076 |
| Maximum | 27.60000038 |
| Range | 15.60000038 |
| Interquartile range (IQR) | 1.299999237 |
Descriptive statistics
| Standard deviation | 1.125211 |
|---|---|
| Coefficient of variation (CV) | 0.05076504084 |
| Kurtosis | 1.827415943 |
| Mean | 22.16507624 |
| Median Absolute Deviation (MAD) | 0.6000003815 |
| Skewness | -0.8915127516 |
| Sum | 18805094.5 |
| Variance | 1.266099691 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 22.60000038 | 40454 | 4.8% |
| 22.70000076 | 38621 | 4.6% |
| 22.79999924 | 38426 | 4.5% |
| 21.89999962 | 36934 | 4.4% |
| 22.5 | 35537 | 4.2% |
| 22.39999962 | 34150 | 4.0% |
| 22.20000076 | 31962 | 3.8% |
| 22.89999962 | 31417 | 3.7% |
| 22.29999924 | 31306 | 3.7% |
| 23 | 31054 | 3.7% |
| Other values (130) | 498550 |
| Value | Count | Frequency (%) |
| 12 | 1 | |
| 12.19999981 | 2 | |
| 12.60000038 | 1 | |
| 12.80000019 | 1 | |
| 12.89999962 | 1 | |
| 13 | 1 | |
| 13.10000038 | 1 | |
| 13.30000019 | 2 | |
| 13.5 | 1 | |
| 13.80000019 | 1 |
| Value | Count | Frequency (%) |
| 27.60000038 | 2 | < 0.1% |
| 27.5 | 2 | < 0.1% |
| 27.39999962 | 10 | |
| 27.29999924 | 5 | < 0.1% |
| 27.20000076 | 5 | < 0.1% |
| 27.10000038 | 3 | < 0.1% |
| 27 | 5 | < 0.1% |
| 26.89999962 | 13 | |
| 26.79999924 | 8 | |
| 26.70000076 | 8 |
| Distinct | 450 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.751688389 |
| Minimum | 0 |
|---|---|
| Maximum | 55.29999924 |
| Zeros | 160732 |
| Zeros (%) | 18.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1.899999976 |
| median | 9.600000381 |
| Q3 | 16.39999962 |
| 95-th percentile | 20.5 |
| Maximum | 55.29999924 |
| Range | 55.29999924 |
| Interquartile range (IQR) | 14.49999964 |
Descriptive statistics
| Standard deviation | 7.78826046 |
|---|---|
| Coefficient of variation (CV) | 0.7986576426 |
| Kurtosis | -0.7705032229 |
| Mean | 9.751688389 |
| Median Absolute Deviation (MAD) | 7.200000286 |
| Skewness | 0.3153251112 |
| Sum | 8273439.698 |
| Variance | 60.65699768 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 160732 | 18.9% |
| 19.29999924 | 27266 | 3.2% |
| 19.20000076 | 22273 | 2.6% |
| 19.10000038 | 17185 | 2.0% |
| 19.39999962 | 14324 | 1.7% |
| 19.5 | 9727 | 1.1% |
| 14.5 | 3723 | 0.4% |
| 13.80000019 | 3701 | 0.4% |
| 14.10000038 | 3675 | 0.4% |
| 14.60000038 | 3603 | 0.4% |
| Other values (440) | 582202 |
| Value | Count | Frequency (%) |
| 0 | 160732 | |
| 0.1000000015 | 2498 | 0.3% |
| 0.200000003 | 2427 | 0.3% |
| 0.3000000119 | 2687 | 0.3% |
| 0.400000006 | 2686 | 0.3% |
| 0.5 | 2508 | 0.3% |
| 0.6000000238 | 2592 | 0.3% |
| 0.6999999881 | 2658 | 0.3% |
| 0.8000000119 | 2760 | 0.3% |
| 0.8999999762 | 2697 | 0.3% |
| Value | Count | Frequency (%) |
| 55.29999924 | 1 | |
| 55 | 1 | |
| 54.70000076 | 1 | |
| 53 | 1 | |
| 49.70000076 | 1 | |
| 49.59999847 | 1 | |
| 48 | 1 | |
| 47.90000153 | 1 | |
| 47 | 1 | |
| 46.79999924 | 1 |
HeaterPerc
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 765 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.180841584 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 497718 |
| Zeros (%) | 58.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1.700000048 |
| 95-th percentile | 29 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 1.700000048 |
Descriptive statistics
| Standard deviation | 12.53284073 |
|---|---|
| Coefficient of variation (CV) | 2.997683714 |
| Kurtosis | 23.16786766 |
| Mean | 4.180841584 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.499892235 |
| Sum | 3547071.989 |
| Variance | 157.0720978 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 497718 | |
| 1.600000024 | 58714 | 6.9% |
| 1.700000048 | 51858 | 6.1% |
| 1.799999952 | 28353 | 3.3% |
| 1.5 | 19770 | 2.3% |
| 0.8999999762 | 12528 | 1.5% |
| 1.399999976 | 11394 | 1.3% |
| 0.8000000119 | 9048 | 1.1% |
| 1.299999952 | 6645 | 0.8% |
| 2.599999905 | 5554 | 0.7% |
| Other values (755) | 146829 | 17.3% |
| Value | Count | Frequency (%) |
| 0 | 497718 | |
| 0.1000000015 | 396 | < 0.1% |
| 0.200000003 | 60 | < 0.1% |
| 0.3000000119 | 36 | < 0.1% |
| 0.400000006 | 31 | < 0.1% |
| 0.5 | 30 | < 0.1% |
| 0.6000000238 | 96 | < 0.1% |
| 0.6999999881 | 948 | 0.1% |
| 0.8000000119 | 9048 | 1.1% |
| 0.8999999762 | 12528 | 1.5% |
| Value | Count | Frequency (%) |
| 100 | 48 | < 0.1% |
| 99.90000153 | 6 | < 0.1% |
| 99.80000305 | 66 | < 0.1% |
| 99.69999695 | 2511 | |
| 99.59999847 | 811 | 0.1% |
| 98.80000305 | 6 | < 0.1% |
| 98.19999695 | 6 | < 0.1% |
| 98.09999847 | 12 | < 0.1% |
| 98 | 12 | < 0.1% |
| 97.90000153 | 6 | < 0.1% |
| Distinct | 477 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.029707539 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 684100 |
| Zeros (%) | 80.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2.599999905 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 6.713343143 |
|---|---|
| Coefficient of variation (CV) | 6.519660088 |
| Kurtosis | 148.5233307 |
| Mean | 1.029707539 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.40591812 |
| Sum | 873615.2028 |
| Variance | 45.06897354 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 684100 | |
| 0.6999999881 | 34009 | 4.0% |
| 0.6000000238 | 31195 | 3.7% |
| 0.8000000119 | 19414 | 2.3% |
| 0.5 | 18097 | 2.1% |
| 0.8999999762 | 4782 | 0.6% |
| 3.599999905 | 3711 | 0.4% |
| 2.5 | 3576 | 0.4% |
| 1.700000048 | 2651 | 0.3% |
| 2.599999905 | 2371 | 0.3% |
| Other values (467) | 44505 | 5.2% |
| Value | Count | Frequency (%) |
| 0 | 684100 | |
| 0.1000000015 | 45 | < 0.1% |
| 0.200000003 | 42 | < 0.1% |
| 0.3000000119 | 66 | < 0.1% |
| 0.400000006 | 884 | 0.1% |
| 0.5 | 18097 | 2.1% |
| 0.6000000238 | 31195 | 3.7% |
| 0.6999999881 | 34009 | 4.0% |
| 0.8000000119 | 19414 | 2.3% |
| 0.8999999762 | 4782 | 0.6% |
| Value | Count | Frequency (%) |
| 100 | 48 | < 0.1% |
| 99.90000153 | 354 | < 0.1% |
| 99.80000305 | 1242 | |
| 99.69999695 | 264 | < 0.1% |
| 97.69999695 | 24 | < 0.1% |
| 97.59999847 | 60 | < 0.1% |
| 97.5 | 24 | < 0.1% |
| 97.40000153 | 12 | < 0.1% |
| 97.30000305 | 6 | < 0.1% |
| 96.59999847 | 36 | < 0.1% |
| Distinct | 1098 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.29385293 |
| Minimum | 0 |
|---|---|
| Maximum | 50 |
| Zeros | 174 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 18.20999908 |
| Q1 | 19.27000046 |
| median | 20.27000046 |
| Q3 | 21.15999985 |
| 95-th percentile | 22.63999939 |
| Maximum | 50 |
| Range | 50 |
| Interquartile range (IQR) | 1.88999939 |
Descriptive statistics
| Standard deviation | 1.480688214 |
|---|---|
| Coefficient of variation (CV) | 0.07296239997 |
| Kurtosis | 14.6123209 |
| Mean | 20.29385293 |
| Median Absolute Deviation (MAD) | 0.9599990845 |
| Skewness | 0.0008916640072 |
| Sum | 17217528.06 |
| Variance | 2.192437649 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20.20999908 | 14299 | 1.7% |
| 19.40999985 | 12060 | 1.4% |
| 18.94000053 | 11749 | 1.4% |
| 19.68000031 | 10793 | 1.3% |
| 20.01000023 | 9961 | 1.2% |
| 20.61000061 | 9846 | 1.2% |
| 20.54000092 | 9619 | 1.1% |
| 20.87999916 | 9567 | 1.1% |
| 19.01000023 | 9115 | 1.1% |
| 20.75 | 9006 | 1.1% |
| Other values (1088) | 742396 |
| Value | Count | Frequency (%) |
| 0 | 174 | |
| 6.610000134 | 6 | < 0.1% |
| 10.60999966 | 6 | < 0.1% |
| 10.64999962 | 6 | < 0.1% |
| 11.86999989 | 6 | < 0.1% |
| 12.60000038 | 6 | < 0.1% |
| 12.81000042 | 6 | < 0.1% |
| 13 | 6 | < 0.1% |
| 13.01000023 | 6 | < 0.1% |
| 13.17000008 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 50 | 36 | |
| 34.72999954 | 6 | < 0.1% |
| 34.49000168 | 6 | < 0.1% |
| 28.28000069 | 6 | < 0.1% |
| 28.22999954 | 6 | < 0.1% |
| 28.21999931 | 6 | < 0.1% |
| 28.18000031 | 6 | < 0.1% |
| 28.10000038 | 6 | < 0.1% |
| 28.02000046 | 12 | < 0.1% |
| 27.88999939 | 6 | < 0.1% |
RelativeHumiditySupplyAir
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 204 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 42.73846614 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 138 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 38.79999924 |
| Q1 | 41.40000153 |
| median | 43.29999924 |
| Q3 | 44.29999924 |
| 95-th percentile | 45.29999924 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 2.899997711 |
Descriptive statistics
| Standard deviation | 2.265540123 |
|---|---|
| Coefficient of variation (CV) | 0.05300939242 |
| Kurtosis | 55.27735138 |
| Mean | 42.73846614 |
| Median Absolute Deviation (MAD) | 1.299999237 |
| Skewness | -0.3923251331 |
| Sum | 36259784.8 |
| Variance | 5.132671833 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 44 | 33471 | 3.9% |
| 44.40000153 | 27173 | 3.2% |
| 43.90000153 | 26899 | 3.2% |
| 43.5 | 23695 | 2.8% |
| 44.5 | 23545 | 2.8% |
| 43.59999847 | 23204 | 2.7% |
| 44.29999924 | 22621 | 2.7% |
| 44.79999924 | 21526 | 2.5% |
| 44.70000076 | 19978 | 2.4% |
| 43.70000076 | 19757 | 2.3% |
| Other values (194) | 606542 |
| Value | Count | Frequency (%) |
| 0 | 138 | |
| 25.5 | 12 | < 0.1% |
| 25.70000076 | 6 | < 0.1% |
| 26 | 12 | < 0.1% |
| 26.10000038 | 12 | < 0.1% |
| 26.39999962 | 12 | < 0.1% |
| 26.5 | 6 | < 0.1% |
| 26.79999924 | 12 | < 0.1% |
| 27.10000038 | 6 | < 0.1% |
| 27.29999924 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 100 | 72 | |
| 51.90000153 | 6 | < 0.1% |
| 51.40000153 | 72 | |
| 51.20000076 | 42 | |
| 51.09999847 | 24 | < 0.1% |
| 51 | 12 | < 0.1% |
| 50.79999924 | 6 | < 0.1% |
| 50.70000076 | 12 | < 0.1% |
| 50.59999847 | 6 | < 0.1% |
| 50.5 | 12 | < 0.1% |
HeatingPower
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 3425 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.48559189 |
| Minimum | -4.699999809 |
|---|---|
| Maximum | 506.7000122 |
| Zeros | 635438 |
| Zeros (%) | 74.9% |
| Negative | 7735 |
| Negative (%) | 0.9% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | -4.699999809 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 136.5 |
| Maximum | 506.7000122 |
| Range | 511.400012 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 57.27389908 |
|---|---|
| Coefficient of variation (CV) | 2.162454942 |
| Kurtosis | 9.612288475 |
| Mean | 26.48559189 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.808483601 |
| Sum | 22470667.5 |
| Variance | 3280.299316 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 635438 | |
| 0.1000000015 | 1010 | 0.1% |
| 66.40000153 | 524 | 0.1% |
| 76.40000153 | 524 | 0.1% |
| 65 | 522 | 0.1% |
| 77.19999695 | 512 | 0.1% |
| 76.59999847 | 493 | 0.1% |
| -4.300000191 | 492 | 0.1% |
| 71.40000153 | 486 | 0.1% |
| 77.5 | 475 | 0.1% |
| Other values (3415) | 207935 | 24.5% |
| Value | Count | Frequency (%) |
| -4.699999809 | 24 | < 0.1% |
| -4.599999905 | 96 | < 0.1% |
| -4.5 | 312 | |
| -4.400000095 | 462 | |
| -4.300000191 | 492 | |
| -4.199999809 | 432 | |
| -4.099999905 | 282 | |
| -4 | 246 | |
| -3.900000095 | 264 | |
| -3.799999952 | 282 |
| Value | Count | Frequency (%) |
| 506.7000122 | 6 | |
| 458.3999939 | 6 | |
| 451 | 6 | |
| 440.2000122 | 6 | |
| 439.3999939 | 6 | |
| 438.3999939 | 6 | |
| 437.3999939 | 6 | |
| 434.7999878 | 12 | |
| 434 | 6 | |
| 433.5 | 6 |
| Distinct | 575 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.920204476 |
| Minimum | 0 |
|---|---|
| Maximum | 68.40000153 |
| Zeros | 754961 |
| Zeros (%) | 89.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 20.60000038 |
| Maximum | 68.40000153 |
| Range | 68.40000153 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 6.840014935 |
|---|---|
| Coefficient of variation (CV) | 3.562128419 |
| Kurtosis | 15.70216465 |
| Mean | 1.920204476 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.886308908 |
| Sum | 1629122.6 |
| Variance | 46.78580475 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 754961 | |
| 0.200000003 | 4837 | 0.6% |
| 0.3000000119 | 3837 | 0.5% |
| 0.1000000015 | 2667 | 0.3% |
| 0.400000006 | 2472 | 0.3% |
| 0.5 | 1836 | 0.2% |
| 0.6000000238 | 1488 | 0.2% |
| 0.6999999881 | 1016 | 0.1% |
| 0.8000000119 | 687 | 0.1% |
| 23.10000038 | 605 | 0.1% |
| Other values (565) | 74005 | 8.7% |
| Value | Count | Frequency (%) |
| 0 | 754961 | |
| 0.1000000015 | 2667 | 0.3% |
| 0.200000003 | 4837 | 0.6% |
| 0.3000000119 | 3837 | 0.5% |
| 0.400000006 | 2472 | 0.3% |
| 0.5 | 1836 | 0.2% |
| 0.6000000238 | 1488 | 0.2% |
| 0.6999999881 | 1016 | 0.1% |
| 0.8000000119 | 687 | 0.1% |
| 0.8999999762 | 390 | < 0.1% |
| Value | Count | Frequency (%) |
| 68.40000153 | 6 | |
| 68 | 6 | |
| 65.5 | 6 | |
| 65.40000153 | 6 | |
| 64.69999695 | 6 | |
| 63 | 6 | |
| 62.29999924 | 6 | |
| 62 | 6 | |
| 61.90000153 | 8 | |
| 61.70000076 | 6 |
| Distinct | 563 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.6955221 |
| Minimum | -16.10000038 |
|---|---|
| Maximum | 41.79999924 |
| Zeros | 1464 |
| Zeros (%) | 0.2% |
| Negative | 37524 |
| Negative (%) | 4.4% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | -16.10000038 |
|---|---|
| 5-th percentile | 0.3000000119 |
| Q1 | 5.5 |
| median | 10.89999962 |
| Q3 | 17.29999924 |
| 95-th percentile | 26.10000038 |
| Maximum | 41.79999924 |
| Range | 57.89999962 |
| Interquartile range (IQR) | 11.79999924 |
Descriptive statistics
| Standard deviation | 8.121736526 |
|---|---|
| Coefficient of variation (CV) | 0.6944312924 |
| Kurtosis | -0.2079547197 |
| Mean | 11.6955221 |
| Median Absolute Deviation (MAD) | 5.800001144 |
| Skewness | 0.3211560845 |
| Sum | 9922609.599 |
| Variance | 65.96260071 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7.699999809 | 5655 | 0.7% |
| 4.599999905 | 5104 | 0.6% |
| 4.400000095 | 5065 | 0.6% |
| 4 | 5033 | 0.6% |
| 7.900000095 | 4989 | 0.6% |
| 3.599999905 | 4978 | 0.6% |
| 11.19999981 | 4880 | 0.6% |
| 6.099999905 | 4838 | 0.6% |
| 6.699999809 | 4752 | 0.6% |
| 5.599999905 | 4743 | 0.6% |
| Other values (553) | 798374 |
| Value | Count | Frequency (%) |
| -16.10000038 | 6 | < 0.1% |
| -15.89999962 | 6 | < 0.1% |
| -15.80000019 | 18 | |
| -15.69999981 | 42 | |
| -15.60000038 | 12 | < 0.1% |
| -15.5 | 18 | |
| -15.39999962 | 12 | < 0.1% |
| -15.30000019 | 12 | < 0.1% |
| -15.19999981 | 12 | < 0.1% |
| -15.10000038 | 18 |
| Value | Count | Frequency (%) |
| 41.79999924 | 12 | |
| 40.70000076 | 6 | < 0.1% |
| 40.59999847 | 12 | |
| 40.40000153 | 6 | < 0.1% |
| 40.09999847 | 6 | < 0.1% |
| 39.90000153 | 24 | |
| 39.70000076 | 12 | |
| 39.59999847 | 12 | |
| 39.5 | 6 | < 0.1% |
| 39.40000153 | 12 |
| Distinct | 361 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 125.9108864 |
| Minimum | 0 |
|---|---|
| Maximum | 360 |
| Zeros | 304105 |
| Zeros (%) | 35.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 90 |
| Q3 | 263 |
| 95-th percentile | 311 |
| Maximum | 360 |
| Range | 360 |
| Interquartile range (IQR) | 263 |
Descriptive statistics
| Standard deviation | 119.4990649 |
|---|---|
| Coefficient of variation (CV) | 0.9490765128 |
| Kurtosis | -1.510857247 |
| Mean | 125.9108864 |
| Median Absolute Deviation (MAD) | 90 |
| Skewness | 0.2848586636 |
| Sum | 106824181 |
| Variance | 14280.02652 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 304105 | |
| 270 | 144461 | |
| 90 | 66548 | 7.8% |
| 180 | 42948 | 5.1% |
| 225 | 21868 | 2.6% |
| 360 | 13047 | 1.5% |
| 315 | 11616 | 1.4% |
| 45 | 5335 | 0.6% |
| 135 | 3818 | 0.5% |
| 86 | 2099 | 0.2% |
| Other values (351) | 232566 |
| Value | Count | Frequency (%) |
| 0 | 304105 | |
| 1 | 175 | < 0.1% |
| 2 | 277 | < 0.1% |
| 3 | 150 | < 0.1% |
| 4 | 150 | < 0.1% |
| 5 | 222 | < 0.1% |
| 6 | 240 | < 0.1% |
| 7 | 204 | < 0.1% |
| 8 | 193 | < 0.1% |
| 9 | 150 | < 0.1% |
| Value | Count | Frequency (%) |
| 360 | 13047 | |
| 359 | 132 | < 0.1% |
| 358 | 228 | < 0.1% |
| 357 | 271 | < 0.1% |
| 356 | 264 | < 0.1% |
| 355 | 193 | < 0.1% |
| 354 | 180 | < 0.1% |
| 353 | 198 | < 0.1% |
| 352 | 192 | < 0.1% |
| 351 | 283 | < 0.1% |
BrightnessNorth
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 469 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.861957945 |
| Minimum | 0 |
|---|---|
| Maximum | 60.09999847 |
| Zeros | 414876 |
| Zeros (%) | 48.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.1000000015 |
| Q3 | 6.900000095 |
| 95-th percentile | 23 |
| Maximum | 60.09999847 |
| Range | 60.09999847 |
| Interquartile range (IQR) | 6.900000095 |
Descriptive statistics
| Standard deviation | 8.102571487 |
|---|---|
| Coefficient of variation (CV) | 1.666524388 |
| Kurtosis | 4.848392487 |
| Mean | 4.861957945 |
| Median Absolute Deviation (MAD) | 0.1000000015 |
| Skewness | 2.174777746 |
| Sum | 4124938.602 |
| Variance | 65.65166473 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 414876 | |
| 0.1000000015 | 10143 | 1.2% |
| 0.200000003 | 9331 | 1.1% |
| 0.5 | 6450 | 0.8% |
| 0.8000000119 | 5615 | 0.7% |
| 0.400000006 | 5568 | 0.7% |
| 0.3000000119 | 5077 | 0.6% |
| 1 | 4652 | 0.5% |
| 0.6999999881 | 4532 | 0.5% |
| 1.100000024 | 4317 | 0.5% |
| Other values (459) | 377850 |
| Value | Count | Frequency (%) |
| 0 | 414876 | |
| 0.1000000015 | 10143 | 1.2% |
| 0.200000003 | 9331 | 1.1% |
| 0.3000000119 | 5077 | 0.6% |
| 0.400000006 | 5568 | 0.7% |
| 0.5 | 6450 | 0.8% |
| 0.6000000238 | 3189 | 0.4% |
| 0.6999999881 | 4532 | 0.5% |
| 0.8000000119 | 5615 | 0.7% |
| 0.8999999762 | 2807 | 0.3% |
| Value | Count | Frequency (%) |
| 60.09999847 | 6 | < 0.1% |
| 55.90000153 | 6 | < 0.1% |
| 55.59999847 | 6 | < 0.1% |
| 54.59999847 | 13 | |
| 53.59999847 | 20 | |
| 53.29999924 | 6 | < 0.1% |
| 52.90000153 | 6 | < 0.1% |
| 52.79999924 | 6 | < 0.1% |
| 52.09999847 | 12 | |
| 51.90000153 | 6 | < 0.1% |
BrightnessEast
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 772 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.33560939 |
| Minimum | 0 |
|---|---|
| Maximum | 145.3000031 |
| Zeros | 414388 |
| Zeros (%) | 48.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.1000000015 |
| Q3 | 8.5 |
| 95-th percentile | 67.90000153 |
| Maximum | 145.3000031 |
| Range | 145.3000031 |
| Interquartile range (IQR) | 8.5 |
Descriptive statistics
| Standard deviation | 21.67531967 |
|---|---|
| Coefficient of variation (CV) | 2.097149655 |
| Kurtosis | 7.137229443 |
| Mean | 10.33560939 |
| Median Absolute Deviation (MAD) | 0.1000000015 |
| Skewness | 2.7415061 |
| Sum | 8768844.699 |
| Variance | 469.819458 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 414388 | |
| 0.1000000015 | 10310 | 1.2% |
| 0.200000003 | 8679 | 1.0% |
| 0.5 | 6651 | 0.8% |
| 0.8000000119 | 5420 | 0.6% |
| 0.400000006 | 5403 | 0.6% |
| 0.3000000119 | 4922 | 0.6% |
| 1.100000024 | 4527 | 0.5% |
| 1.299999952 | 4113 | 0.5% |
| 1 | 4095 | 0.5% |
| Other values (762) | 379903 |
| Value | Count | Frequency (%) |
| 0 | 414388 | |
| 0.1000000015 | 10310 | 1.2% |
| 0.200000003 | 8679 | 1.0% |
| 0.3000000119 | 4922 | 0.6% |
| 0.400000006 | 5403 | 0.6% |
| 0.5 | 6651 | 0.8% |
| 0.6000000238 | 3161 | 0.4% |
| 0.6999999881 | 4065 | 0.5% |
| 0.8000000119 | 5420 | 0.6% |
| 0.8999999762 | 2743 | 0.3% |
| Value | Count | Frequency (%) |
| 145.3000031 | 6 | |
| 143.6000061 | 6 | |
| 142.8000031 | 6 | |
| 141.8999939 | 6 | |
| 140.6000061 | 6 | |
| 140.1999969 | 6 | |
| 139.8000031 | 6 | |
| 139 | 6 | |
| 138.1000061 | 6 | |
| 137.3000031 | 6 |
BrightnessSouth
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 784 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.62331134 |
| Minimum | 0 |
|---|---|
| Maximum | 158.3999939 |
| Zeros | 415732 |
| Zeros (%) | 49.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.1000000015 |
| Q3 | 9.5 |
| 95-th percentile | 75.59999847 |
| Maximum | 158.3999939 |
| Range | 158.3999939 |
| Interquartile range (IQR) | 9.5 |
Descriptive statistics
| Standard deviation | 23.80919266 |
|---|---|
| Coefficient of variation (CV) | 2.048400147 |
| Kurtosis | 5.854674816 |
| Mean | 11.62331134 |
| Median Absolute Deviation (MAD) | 0.1000000015 |
| Skewness | 2.54088974 |
| Sum | 9861345.195 |
| Variance | 566.8776245 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 415732 | |
| 0.1000000015 | 10508 | 1.2% |
| 0.200000003 | 8992 | 1.1% |
| 0.5 | 6397 | 0.8% |
| 0.8000000119 | 5857 | 0.7% |
| 0.400000006 | 5763 | 0.7% |
| 0.3000000119 | 5089 | 0.6% |
| 0.6999999881 | 4469 | 0.5% |
| 1.100000024 | 4284 | 0.5% |
| 1 | 4260 | 0.5% |
| Other values (774) | 377060 |
| Value | Count | Frequency (%) |
| 0 | 415732 | |
| 0.1000000015 | 10508 | 1.2% |
| 0.200000003 | 8992 | 1.1% |
| 0.3000000119 | 5089 | 0.6% |
| 0.400000006 | 5763 | 0.7% |
| 0.5 | 6397 | 0.8% |
| 0.6000000238 | 3458 | 0.4% |
| 0.6999999881 | 4469 | 0.5% |
| 0.8000000119 | 5857 | 0.7% |
| 0.8999999762 | 2943 | 0.3% |
| Value | Count | Frequency (%) |
| 158.3999939 | 19 | |
| 158 | 6 | < 0.1% |
| 157.6000061 | 6 | < 0.1% |
| 155.8999939 | 6 | < 0.1% |
| 147.8000031 | 12 | |
| 146.1000061 | 6 | < 0.1% |
| 145.3000031 | 12 | |
| 144 | 18 | |
| 142.8000031 | 6 | < 0.1% |
| 142.3000031 | 18 |
BrightnessWest
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 743 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.974496199 |
| Minimum | 0 |
|---|---|
| Maximum | 147.3999939 |
| Zeros | 413508 |
| Zeros (%) | 48.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.200000003 |
| Q3 | 8.899999619 |
| 95-th percentile | 51.59999847 |
| Maximum | 147.3999939 |
| Range | 147.3999939 |
| Interquartile range (IQR) | 8.899999619 |
Descriptive statistics
| Standard deviation | 18.51635933 |
|---|---|
| Coefficient of variation (CV) | 2.06321992 |
| Kurtosis | 9.912195206 |
| Mean | 8.974496199 |
| Median Absolute Deviation (MAD) | 0.200000003 |
| Skewness | 3.050058842 |
| Sum | 7614061.295 |
| Variance | 342.8555298 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 413508 | |
| 0.1000000015 | 9893 | 1.2% |
| 0.200000003 | 8063 | 1.0% |
| 0.5 | 5945 | 0.7% |
| 0.400000006 | 5174 | 0.6% |
| 0.3000000119 | 4861 | 0.6% |
| 0.8000000119 | 4850 | 0.6% |
| 1 | 3886 | 0.5% |
| 1.100000024 | 3878 | 0.5% |
| 0.6999999881 | 3800 | 0.4% |
| Other values (733) | 384553 |
| Value | Count | Frequency (%) |
| 0 | 413508 | |
| 0.1000000015 | 9893 | 1.2% |
| 0.200000003 | 8063 | 1.0% |
| 0.3000000119 | 4861 | 0.6% |
| 0.400000006 | 5174 | 0.6% |
| 0.5 | 5945 | 0.7% |
| 0.6000000238 | 2910 | 0.3% |
| 0.6999999881 | 3800 | 0.4% |
| 0.8000000119 | 4850 | 0.6% |
| 0.8999999762 | 2947 | 0.3% |
| Value | Count | Frequency (%) |
| 147.3999939 | 6 | |
| 143.6000061 | 6 | |
| 143.1999969 | 6 | |
| 140.6000061 | 12 | |
| 138.1000061 | 6 | |
| 137.3000031 | 6 | |
| 136 | 6 | |
| 135.6000061 | 6 | |
| 133 | 6 | |
| 129.6999969 | 6 |
Beamerstate
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 46.9 MiB |
| 0 | |
|---|---|
| 1 | 39256 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 848411 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 809155 | |
| 1 | 39256 | 4.6% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 809155 | |
| 1 | 39256 | 4.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 809155 | |
| 1 | 39256 | 4.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 848411 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 809155 | |
| 1 | 39256 | 4.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 848411 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 809155 | |
| 1 | 39256 | 4.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 848411 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 809155 | |
| 1 | 39256 | 4.6% |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.04579384284 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 818422 |
| Zeros (%) | 96.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2730726726 |
|---|---|
| Coefficient of variation (CV) | 5.963087079 |
| Kurtosis | 84.23380299 |
| Mean | 0.04579384284 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.11346996 |
| Sum | 38852 |
| Variance | 0.0745686845 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 818422 | |
| 1 | 24428 | 2.9% |
| 2 | 3109 | 0.4% |
| 3 | 1676 | 0.2% |
| 4 | 709 | 0.1% |
| 5 | 60 | < 0.1% |
| 6 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 818422 | |
| 1 | 24428 | 2.9% |
| 2 | 3109 | 0.4% |
| 3 | 1676 | 0.2% |
| 4 | 709 | 0.1% |
| 5 | 60 | < 0.1% |
| 6 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 6 | 7 | < 0.1% |
| 5 | 60 | < 0.1% |
| 4 | 709 | 0.1% |
| 3 | 1676 | 0.2% |
| 2 | 3109 | 0.4% |
| 1 | 24428 | 2.9% |
| 0 | 818422 |
| Distinct | 2806 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.12271461 |
| Minimum | -22.8 |
|---|---|
| Maximum | 23 |
| Zeros | 1878 |
| Zeros (%) | 0.2% |
| Negative | 128952 |
| Negative (%) | 15.2% |
| Memory size | 6.5 MiB |
Quantile statistics
| Minimum | -22.8 |
|---|---|
| 5-th percentile | -3.3 |
| Q1 | 1.7 |
| median | 6.15 |
| Q3 | 10.85 |
| 95-th percentile | 15.6 |
| Maximum | 23 |
| Range | 45.8 |
| Interquartile range (IQR) | 9.15 |
Descriptive statistics
| Standard deviation | 6.114669039 |
|---|---|
| Coefficient of variation (CV) | 0.9986859471 |
| Kurtosis | 0.02577060591 |
| Mean | 6.12271461 |
| Median Absolute Deviation (MAD) | 4.55 |
| Skewness | -0.2833830907 |
| Sum | 5194578.425 |
| Variance | 37.38917746 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9.5 | 2768 | 0.3% |
| 1.9 | 2662 | 0.3% |
| 1.4 | 2656 | 0.3% |
| 2.1 | 2629 | 0.3% |
| 2 | 2617 | 0.3% |
| 1.1 | 2617 | 0.3% |
| 0.7 | 2593 | 0.3% |
| 8.3 | 2536 | 0.3% |
| 5.1 | 2521 | 0.3% |
| 3.5 | 2515 | 0.3% |
| Other values (2796) | 822297 |
| Value | Count | Frequency (%) |
| -22.8 | 6 | |
| -22.75 | 6 | |
| -22.7 | 6 | |
| -22.65 | 6 | |
| -22.6 | 6 | |
| -22.5 | 6 | |
| -22.325 | 6 | |
| -22.2 | 6 | |
| -22.05 | 6 | |
| -22 | 6 |
| Value | Count | Frequency (%) |
| 23 | 6 | |
| 22.525 | 6 | |
| 22.4 | 6 | |
| 22.05 | 6 | |
| 21.8 | 12 | |
| 21.625 | 6 | |
| 21.575 | 6 | |
| 21.575 | 6 | |
| 21.45 | 6 | |
| 21.35 | 6 |
| Distinct | 330 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 77.09964186 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 18 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 41.5 |
| Q1 | 67 |
| median | 81.5 |
| Q3 | 90.75 |
| 95-th percentile | 98 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 23.75 |
Descriptive statistics
| Standard deviation | 17.41226757 |
|---|---|
| Coefficient of variation (CV) | 0.2258410954 |
| Kurtosis | -0.009567350005 |
| Mean | 77.09964186 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | -0.8783361371 |
| Sum | 65412184.25 |
| Variance | 303.187062 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 90 | 12188 | 1.4% |
| 98 | 12137 | 1.4% |
| 93 | 11856 | 1.4% |
| 95 | 11845 | 1.4% |
| 100 | 11826 | 1.4% |
| 96 | 11787 | 1.4% |
| 89 | 11717 | 1.4% |
| 84 | 11712 | 1.4% |
| 91 | 11648 | 1.4% |
| 92 | 11617 | 1.4% |
| Other values (320) | 730078 |
| Value | Count | Frequency (%) |
| 0 | 18 | < 0.1% |
| 17 | 6 | < 0.1% |
| 18 | 42 | |
| 18.25 | 6 | < 0.1% |
| 18.5 | 18 | < 0.1% |
| 18.75 | 6 | < 0.1% |
| 19 | 78 | |
| 19.5 | 24 | < 0.1% |
| 19.75 | 12 | < 0.1% |
| 20 | 42 |
| Value | Count | Frequency (%) |
| 100 | 11826 | |
| 99.75 | 2022 | 0.2% |
| 99.5 | 2586 | 0.3% |
| 99.25 | 2190 | 0.3% |
| 99 | 11148 | |
| 98.75 | 2528 | 0.3% |
| 98.5 | 4172 | 0.5% |
| 98.25 | 2864 | 0.3% |
| 98 | 12137 | |
| 97.75 | 2611 | 0.3% |
| Distinct | 470 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.07265720859 |
| Minimum | 0 |
|---|---|
| Maximum | 26.2 |
| Zeros | 734300 |
| Zeros (%) | 86.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.375 |
| Maximum | 26.2 |
| Range | 26.2 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.4150709894 |
|---|---|
| Coefficient of variation (CV) | 5.712729644 |
| Kurtosis | 563.5979352 |
| Mean | 0.07265720859 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 17.65664282 |
| Sum | 61643.175 |
| Variance | 0.1722839262 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 734300 | |
| 0.1 | 13368 | 1.6% |
| 0.05 | 8305 | 1.0% |
| 0.075 | 7609 | 0.9% |
| 0.2 | 6362 | 0.7% |
| 0.15 | 4444 | 0.5% |
| 0.025 | 3550 | 0.4% |
| 0.3 | 3450 | 0.4% |
| 0.4 | 3306 | 0.4% |
| 0.025 | 3260 | 0.4% |
| Other values (460) | 60457 | 7.1% |
| Value | Count | Frequency (%) |
| 0 | 734300 | |
| 0.025 | 3550 | 0.4% |
| 0.025 | 3260 | 0.4% |
| 0.05 | 1527 | 0.2% |
| 0.05 | 8305 | 1.0% |
| 0.075 | 721 | 0.1% |
| 0.075 | 7609 | 0.9% |
| 0.1 | 457 | 0.1% |
| 0.1 | 13368 | 1.6% |
| 0.125 | 1960 | 0.2% |
| Value | Count | Frequency (%) |
| 26.2 | 6 | |
| 21.8 | 6 | |
| 21.15 | 6 | |
| 20.225 | 6 | |
| 18.5 | 6 | |
| 17.5 | 6 | |
| 17 | 6 | |
| 16.5 | 6 | |
| 16.4 | 6 | |
| 16.1 | 6 |
wspd
Real number (ℝ≥0)
| Distinct | 2182 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.03301996 |
| Minimum | 0 |
|---|---|
| Maximum | 54 |
| Zeros | 18 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3.625 |
| Q1 | 7.125 |
| median | 10.95 |
| Q3 | 15.725 |
| 95-th percentile | 24.3 |
| Maximum | 54 |
| Range | 54 |
| Interquartile range (IQR) | 8.6 |
Descriptive statistics
| Standard deviation | 6.444632637 |
|---|---|
| Coefficient of variation (CV) | 0.5355789865 |
| Kurtosis | 0.9798285413 |
| Mean | 12.03301996 |
| Median Absolute Deviation (MAD) | 4.15 |
| Skewness | 0.9269693532 |
| Sum | 10208946.5 |
| Variance | 41.53328983 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5.4 | 8198 | 1.0% |
| 9 | 8077 | 1.0% |
| 10.8 | 7957 | 0.9% |
| 7.2 | 7936 | 0.9% |
| 6.1 | 7928 | 0.9% |
| 6.5 | 7704 | 0.9% |
| 8.3 | 7481 | 0.9% |
| 9.7 | 7473 | 0.9% |
| 7.6 | 7218 | 0.9% |
| 10.1 | 7057 | 0.8% |
| Other values (2172) | 771382 |
| Value | Count | Frequency (%) |
| 0 | 18 | < 0.1% |
| 0.4 | 54 | < 0.1% |
| 0.475 | 24 | < 0.1% |
| 0.55 | 24 | < 0.1% |
| 0.625 | 24 | < 0.1% |
| 0.7 | 162 | |
| 0.75 | 12 | < 0.1% |
| 0.8 | 30 | < 0.1% |
| 0.85 | 6 | < 0.1% |
| 0.875 | 48 | < 0.1% |
| Value | Count | Frequency (%) |
| 54 | 6 | |
| 52.375 | 6 | |
| 52.2 | 12 | |
| 51.4 | 6 | |
| 51.125 | 6 | |
| 50.75 | 6 | |
| 50.6 | 6 | |
| 50.4 | 6 | |
| 50.05 | 6 | |
| 49.8 | 6 |
| Distinct | 281 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.09812726 |
| Minimum | 0 |
|---|---|
| Maximum | 60 |
| Zeros | 568344 |
| Zeros (%) | 67.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 10.75 |
| 95-th percentile | 60 |
| Maximum | 60 |
| Range | 60 |
| Interquartile range (IQR) | 10.75 |
Descriptive statistics
| Standard deviation | 20.33364974 |
|---|---|
| Coefficient of variation (CV) | 1.832169452 |
| Kurtosis | 0.9171284956 |
| Mean | 11.09812726 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.601715103 |
| Sum | 9415773.25 |
| Variance | 413.4573119 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 568344 | |
| 60 | 63656 | 7.5% |
| 1 | 5070 | 0.6% |
| 0.5 | 3738 | 0.4% |
| 3 | 3707 | 0.4% |
| 1.5 | 3542 | 0.4% |
| 2 | 3304 | 0.4% |
| 0.75 | 3294 | 0.4% |
| 59 | 2938 | 0.3% |
| 6 | 2647 | 0.3% |
| Other values (271) | 188171 | 22.2% |
| Value | Count | Frequency (%) |
| 0 | 568344 | |
| 0.25 | 2208 | 0.3% |
| 0.375 | 6 | < 0.1% |
| 0.5 | 3738 | 0.4% |
| 0.75 | 3294 | 0.4% |
| 1 | 5070 | 0.6% |
| 1.125 | 6 | < 0.1% |
| 1.25 | 836 | 0.1% |
| 1.416666667 | 6 | < 0.1% |
| 1.5 | 3542 | 0.4% |
| Value | Count | Frequency (%) |
| 60 | 63656 | |
| 59.75 | 1161 | 0.1% |
| 59.5 | 1750 | 0.2% |
| 59.25 | 1610 | 0.2% |
| 59.125 | 6 | < 0.1% |
| 59 | 2938 | 0.3% |
| 58.75 | 511 | 0.1% |
| 58.5 | 1516 | 0.2% |
| 58.25 | 546 | 0.1% |
| 58 | 1954 | 0.2% |
| Distinct | 147 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.351226292 |
| Minimum | 0 |
|---|---|
| Maximum | 25 |
| Zeros | 15378 |
| Zeros (%) | 1.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2.25 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 8 |
| Maximum | 25 |
| Range | 25 |
| Interquartile range (IQR) | 3.75 |
Descriptive statistics
| Standard deviation | 2.940262781 |
|---|---|
| Coefficient of variation (CV) | 0.6757319854 |
| Kurtosis | 4.024227738 |
| Mean | 4.351226292 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 1.46220686 |
| Sum | 3691628.25 |
| Variance | 8.645145224 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 265065 | |
| 1 | 136257 | |
| 8 | 93397 | 11.0% |
| 7 | 43759 | 5.2% |
| 3 | 33720 | 4.0% |
| 5 | 26974 | 3.2% |
| 2 | 25616 | 3.0% |
| 2.5 | 20264 | 2.4% |
| 3.5 | 17872 | 2.1% |
| 3.25 | 17666 | 2.1% |
| Other values (137) | 167821 |
| Value | Count | Frequency (%) |
| 0 | 15378 | 1.8% |
| 1 | 136257 | |
| 1.083333333 | 18 | < 0.1% |
| 1.083333333 | 6 | < 0.1% |
| 1.125 | 18 | < 0.1% |
| 1.166666667 | 24 | < 0.1% |
| 1.25 | 6573 | 0.8% |
| 1.333333333 | 18 | < 0.1% |
| 1.333333333 | 6 | < 0.1% |
| 1.375 | 30 | < 0.1% |
| Value | Count | Frequency (%) |
| 25 | 360 | |
| 23.25 | 18 | < 0.1% |
| 23 | 6 | < 0.1% |
| 21.5 | 18 | < 0.1% |
| 21 | 738 | |
| 20.75 | 6 | < 0.1% |
| 20.25 | 12 | < 0.1% |
| 19.75 | 24 | < 0.1% |
| 19.5 | 24 | < 0.1% |
| 19.25 | 24 | < 0.1% |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| df_index | Room | RoomTemperature | AirqualityPerc | HeaterPerc | CoolerPerc | TempSupplyAir | RelativeHumiditySupplyAir | HeatingPower | CoolingPower | AirTemperature | WindDirection | BrightnessNorth | BrightnessEast | BrightnessSouth | BrightnessWest | Beamerstate | BucketAttendees | dwpt | rhum | prcp | wspd | tsun | coco | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2018-01-01 00:00:00 | 0.0 | 21.299999 | 0.0 | 0.0 | 0.0 | 18.40 | 40.799999 | 0.0 | 1.4 | 9.5 | 235 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 6.5 | 81.0 | 0.0 | 22.3 | 0.0 | 0.0 |
| 1 | 2018-01-01 00:00:00 | 1.0 | 21.600000 | 0.0 | 0.0 | 0.0 | 18.40 | 40.799999 | 0.0 | 1.4 | 9.5 | 235 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 6.5 | 81.0 | 0.0 | 22.3 | 0.0 | 0.0 |
| 2 | 2018-01-01 00:00:00 | 2.0 | 21.799999 | 0.0 | 0.0 | 0.0 | 18.40 | 40.799999 | 0.0 | 1.4 | 9.5 | 235 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 6.5 | 81.0 | 0.0 | 22.3 | 0.0 | 0.0 |
| 3 | 2018-01-01 00:00:00 | 3.0 | 21.900000 | 0.0 | 0.0 | 0.0 | 18.40 | 40.799999 | 0.0 | 1.4 | 9.5 | 235 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 6.5 | 81.0 | 0.0 | 22.3 | 0.0 | 0.0 |
| 4 | 2018-01-01 00:00:00 | 4.0 | 20.400000 | 0.0 | 0.0 | 0.0 | 18.40 | 40.799999 | 0.0 | 1.4 | 9.5 | 235 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 6.5 | 81.0 | 0.0 | 22.3 | 0.0 | 0.0 |
| 5 | 2018-01-01 00:00:00 | 5.0 | 21.900000 | 0.0 | 0.0 | 0.0 | 18.40 | 40.799999 | 0.0 | 1.4 | 9.5 | 235 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 6.5 | 81.0 | 0.0 | 22.3 | 0.0 | 0.0 |
| 6 | 2018-01-01 00:15:00 | 0.0 | 21.299999 | 0.0 | 0.0 | 0.0 | 18.33 | 40.799999 | 0.0 | 0.5 | 9.5 | 253 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 6.3 | 80.0 | 0.0 | 22.4 | 0.0 | 0.0 |
| 7 | 2018-01-01 00:15:00 | 1.0 | 21.600000 | 0.0 | 0.0 | 0.0 | 18.33 | 40.799999 | 0.0 | 0.5 | 9.5 | 253 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 6.3 | 80.0 | 0.0 | 22.4 | 0.0 | 0.0 |
| 8 | 2018-01-01 00:15:00 | 2.0 | 21.900000 | 0.0 | 0.0 | 0.0 | 18.33 | 40.799999 | 0.0 | 0.5 | 9.5 | 253 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 6.3 | 80.0 | 0.0 | 22.4 | 0.0 | 0.0 |
| 9 | 2018-01-01 00:15:00 | 3.0 | 21.900000 | 0.0 | 0.0 | 0.0 | 18.33 | 40.799999 | 0.0 | 0.5 | 9.5 | 253 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 6.3 | 80.0 | 0.0 | 22.4 | 0.0 | 0.0 |
Last rows
| df_index | Room | RoomTemperature | AirqualityPerc | HeaterPerc | CoolerPerc | TempSupplyAir | RelativeHumiditySupplyAir | HeatingPower | CoolingPower | AirTemperature | WindDirection | BrightnessNorth | BrightnessEast | BrightnessSouth | BrightnessWest | Beamerstate | BucketAttendees | dwpt | rhum | prcp | wspd | tsun | coco | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 848401 | 2021-12-31 23:30:00 | 2.0 | 19.600000 | 23.700001 | 1.4 | 0.9 | 17.530001 | 38.000000 | 0.0 | 0.2 | 12.9 | 270 | 0.0 | 0.0 | 0.0 | 0.0 | 1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 848402 | 2021-12-31 23:30:00 | 3.0 | 19.000000 | 9.000000 | 1.4 | 0.9 | 17.530001 | 38.000000 | 0.0 | 0.2 | 12.9 | 270 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 848403 | 2021-12-31 23:30:00 | 4.0 | 18.299999 | 20.200001 | 1.4 | 0.9 | 17.530001 | 38.000000 | 0.0 | 0.2 | 12.9 | 270 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 848404 | 2021-12-31 23:30:00 | 5.0 | 18.799999 | 25.100000 | 1.4 | 0.9 | 17.530001 | 38.000000 | 0.0 | 0.2 | 12.9 | 270 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 848405 | 2021-12-31 23:45:00 | 0.0 | 18.500000 | 16.799999 | 1.3 | 0.9 | 17.590000 | 38.099998 | 0.0 | 0.2 | 12.7 | 315 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 848406 | 2021-12-31 23:45:00 | 1.0 | 19.400000 | 21.000000 | 1.3 | 0.9 | 17.590000 | 38.099998 | 0.0 | 0.2 | 12.7 | 315 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 848407 | 2021-12-31 23:45:00 | 2.0 | 19.600000 | 23.600000 | 1.3 | 0.9 | 17.590000 | 38.099998 | 0.0 | 0.2 | 12.7 | 315 | 0.0 | 0.0 | 0.0 | 0.0 | 1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 848408 | 2021-12-31 23:45:00 | 3.0 | 19.000000 | 9.200000 | 1.3 | 0.9 | 17.590000 | 38.099998 | 0.0 | 0.2 | 12.7 | 315 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 848409 | 2021-12-31 23:45:00 | 4.0 | 18.299999 | 20.200001 | 1.3 | 0.9 | 17.590000 | 38.099998 | 0.0 | 0.2 | 12.7 | 315 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 848410 | 2021-12-31 23:45:00 | 5.0 | 18.900000 | 25.200001 | 1.3 | 0.9 | 17.590000 | 38.099998 | 0.0 | 0.2 | 12.7 | 315 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
Most frequently occurring
| df_index | Room | RoomTemperature | AirqualityPerc | HeaterPerc | CoolerPerc | TempSupplyAir | RelativeHumiditySupplyAir | HeatingPower | CoolingPower | AirTemperature | WindDirection | BrightnessNorth | BrightnessEast | BrightnessSouth | BrightnessWest | Beamerstate | BucketAttendees | dwpt | rhum | prcp | wspd | tsun | coco | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96 | 2018-10-28 02:30:00 | 4.0 | 20.9 | 0.0 | 0.0 | 0.0 | 19.48 | 42.000000 | 0.0 | 0.0 | 3.600000 | 86 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 1.850 | 89.50 | 0.0 | 12.4 | 0.0 | 4.0 | 64 |
| 97 | 2018-10-28 02:30:00 | 4.0 | 20.9 | 0.0 | 0.0 | 0.0 | 19.48 | 42.000000 | 0.0 | 0.0 | 4.000000 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 1.850 | 89.50 | 0.0 | 12.4 | 0.0 | 4.0 | 64 |
| 98 | 2018-10-28 02:30:00 | 5.0 | 22.6 | 0.0 | 0.0 | 0.0 | 19.48 | 42.000000 | 0.0 | 0.0 | 3.600000 | 86 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 1.850 | 89.50 | 0.0 | 12.4 | 0.0 | 4.0 | 64 |
| 99 | 2018-10-28 02:30:00 | 5.0 | 22.6 | 0.0 | 0.0 | 0.0 | 19.48 | 42.000000 | 0.0 | 0.0 | 4.000000 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 1.850 | 89.50 | 0.0 | 12.4 | 0.0 | 4.0 | 64 |
| 124 | 2018-10-28 02:45:00 | 4.0 | 20.9 | 0.0 | 0.0 | 0.0 | 19.48 | 42.000000 | 0.0 | 0.0 | 3.600000 | 61 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 1.825 | 89.25 | 0.0 | 12.5 | 0.0 | 4.0 | 64 |
| 125 | 2018-10-28 02:45:00 | 4.0 | 20.9 | 0.0 | 0.0 | 0.0 | 19.48 | 42.000000 | 0.0 | 0.0 | 4.000000 | 360 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 1.825 | 89.25 | 0.0 | 12.5 | 0.0 | 4.0 | 64 |
| 126 | 2018-10-28 02:45:00 | 5.0 | 22.6 | 0.0 | 0.0 | 0.0 | 19.48 | 42.000000 | 0.0 | 0.0 | 3.600000 | 61 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 1.825 | 89.25 | 0.0 | 12.5 | 0.0 | 4.0 | 64 |
| 127 | 2018-10-28 02:45:00 | 5.0 | 22.6 | 0.0 | 0.0 | 0.0 | 19.48 | 42.000000 | 0.0 | 0.0 | 4.000000 | 360 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 1.825 | 89.25 | 0.0 | 12.5 | 0.0 | 4.0 | 64 |
| 144 | 2019-10-27 02:00:00 | 4.0 | 21.9 | 0.0 | 1.6 | 0.0 | 20.01 | 42.700001 | 0.0 | 0.0 | 16.200001 | 207 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 10.500 | 67.00 | 0.0 | 24.1 | 0.0 | 4.0 | 64 |
| 145 | 2019-10-27 02:00:00 | 4.0 | 21.9 | 0.0 | 1.6 | 0.0 | 20.01 | 42.700001 | 0.0 | 0.0 | 17.400000 | 269 | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0.0 | 10.500 | 67.00 | 0.0 | 24.1 | 0.0 | 4.0 | 64 |